Tabela OncologyHospital

Definicja tabeli OncologyHospital

Name

OncologyHospital

Code

OncologyHospital

Comment

Tabela do zapisu diagnostyki szpitalnej


Lista kolumn tabeli OncologyHospital

Name

Code

OncologyHospitalID

OncologyHospitalID

OncologicCardID

OncologicCardID

OtherSymptomDescrID

OtherSymptomDescrID

OtherPerfTestDescrID

OtherPerfTestDescrID

OthersInformationDescrID

OthersInformationDescrID

TumourICDID

TumourICDID

AdvanceLevelID

AdvanceLevelID

AdvanceStageID

AdvanceStageID

DiagnosisDoctorID

DiagnosisDoctorID

IssuingOrgUnitID

IssuingOrgUnitID

HistopatologyICDID

HistopatologyICDID

AdvanceLevelScaleID

AdvanceLevelScaleID

MalignantTumourCardNo

MalignantTumourCardNo

KZNZCancerNotificationDT

KZNZCancerNotificationDT

AdvanceLevelScaleValue

AdvanceLevelScaleValue

HistopatologyDescrID

HistopatologyDescrID

WaitingListItemStartDT

WaitingListItemStartDT

DiagnSurgProcedureDT

DiagnSurgProcedureDT

FurtherProceedingID

FurtherProceedingID

FurtherProceedingSpecialityID

FurtherProceedingSpecialityID

IssuedBecauseHCProviderChange

IssuedBecauseHCProviderChange

FurtherProceedingSpecialityDT

FurtherProceedingSpecialityDT


Kolumna OncologyHospitalID tabeli OncologyHospital

Definicja kolumny OncologyHospitalID tabeli OncologyHospital

Name

OncologyHospitalID

Code

OncologyHospitalID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

klucz glówny


Kolumna OncologicCardID tabeli OncologyHospital

Definicja kolumny OncologicCardID tabeli OncologyHospital

Name

OncologicCardID

Code

OncologicCardID

Data Type

NUMBER(10)

Mandatory

No

Comment

id karty


Kolumna OtherSymptomDescrID tabeli OncologyHospital

Definicja kolumny OtherSymptomDescrID tabeli OncologyHospital

Name

OtherSymptomDescrID

Code

OtherSymptomDescrID

Data Type

NUMBER(10)

Mandatory

No

Comment

opis innych objawów


Kolumna OtherPerfTestDescrID tabeli OncologyHospital

Definicja kolumny OtherPerfTestDescrID tabeli OncologyHospital

Name

OtherPerfTestDescrID

Code

OtherPerfTestDescrID

Data Type

NUMBER(10)

Mandatory

No

Comment

opis innych wynikow


Kolumna OthersInformationDescrID tabeli OncologyHospital

Definicja kolumny OthersInformationDescrID tabeli OncologyHospital

Name

OthersInformationDescrID

Code

OthersInformationDescrID

Data Type

NUMBER(10)

Mandatory

No

Comment

pozostale informacje


Kolumna TumourICDID tabeli OncologyHospital

Definicja kolumny TumourICDID tabeli OncologyHospital

Name

TumourICDID

Code

TumourICDID

Data Type

NUMBER(10)

Mandatory

No

Comment

ICDID nowotworu


Kolumna AdvanceLevelID tabeli OncologyHospital

Definicja kolumny AdvanceLevelID tabeli OncologyHospital

Name

AdvanceLevelID

Code

AdvanceLevelID

Data Type

NUMBER(10)

Mandatory

No

Comment

stopien zaawansowania


Kolumna AdvanceStageID tabeli OncologyHospital

Definicja kolumny AdvanceStageID tabeli OncologyHospital

Name

AdvanceStageID

Code

AdvanceStageID

Data Type

NUMBER(10)

Mandatory

No

Comment

stadium zaawansowania


Kolumna DiagnosisDoctorID tabeli OncologyHospital

Definicja kolumny DiagnosisDoctorID tabeli OncologyHospital

Name

DiagnosisDoctorID

Code

DiagnosisDoctorID

Data Type

NUMBER(10)

Mandatory

No

Comment

lekarz stawiajacy rozpoznanie


Kolumna IssuingOrgUnitID tabeli OncologyHospital

Definicja kolumny IssuingOrgUnitID tabeli OncologyHospital

Name

IssuingOrgUnitID

Code

IssuingOrgUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

swiadczeniodawaca


Kolumna HistopatologyICDID tabeli OncologyHospital

Definicja kolumny HistopatologyICDID tabeli OncologyHospital

Name

HistopatologyICDID

Code

HistopatologyICDID

Data Type

NUMBER(10)

Mandatory

No

Comment

rozpoznanie histopatologiczne


Kolumna AdvanceLevelScaleID tabeli OncologyHospital

Definicja kolumny AdvanceLevelScaleID tabeli OncologyHospital

Name

AdvanceLevelScaleID

Code

AdvanceLevelScaleID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna MalignantTumourCardNo tabeli OncologyHospital

Definicja kolumny MalignantTumourCardNo tabeli OncologyHospital

Name

MalignantTumourCardNo

Code

MalignantTumourCardNo

Data Type

VARCHAR2(20)

Mandatory

No

Comment

numer karty kznz


Kolumna KZNZCancerNotificationDT tabeli OncologyHospital

Definicja kolumny KZNZCancerNotificationDT tabeli OncologyHospital

Name

KZNZCancerNotificationDT

Code

KZNZCancerNotificationDT

Data Type

DATE

Mandatory

No

Comment

data zgloszenia nowotworu do KZNZ


Kolumna AdvanceLevelScaleValue tabeli OncologyHospital

Definicja kolumny AdvanceLevelScaleValue tabeli OncologyHospital

Name

AdvanceLevelScaleValue

Code

AdvanceLevelScaleValue

Data Type

VARCHAR2(32)

Mandatory

No

Comment

Kolumna bedzie przechowyac dana opisowa rozpoznania histopatologicznego
(zastapi pole HistopatologyICDID)


Kolumna HistopatologyDescrID tabeli OncologyHospital

Definicja kolumny HistopatologyDescrID tabeli OncologyHospital

Name

HistopatologyDescrID

Code

HistopatologyDescrID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna WaitingListItemStartDT tabeli OncologyHospital

Definicja kolumny WaitingListItemStartDT tabeli OncologyHospital

Name

WaitingListItemStartDT

Code

WaitingListItemStartDT

Data Type

DATE

Mandatory

No

Comment

Leczenie szpitalne - Data wpisu na liste oczekujacych na udzielenie swiadczenia opieki zdrowotnej


Kolumna DiagnSurgProcedureDT tabeli OncologyHospital

Definicja kolumny DiagnSurgProcedureDT tabeli OncologyHospital

Name

DiagnSurgProcedureDT

Code

DiagnSurgProcedureDT

Data Type

DATE

Mandatory

No

Comment

Leczenie szpitalne - Data zabiegu diagnostyczno-leczniczego


Kolumna FurtherProceedingID tabeli OncologyHospital

Definicja kolumny FurtherProceedingID tabeli OncologyHospital

Name

FurtherProceedingID

Code

FurtherProceedingID

Data Type

NUMBER(10)

Mandatory

No

Comment

Leczenie szpitalne - Dalsze Postepowanie


Kolumna FurtherProceedingSpecialityID tabeli OncologyHospital

Definicja kolumny FurtherProceedingSpecialityID tabeli OncologyHospital

Name

FurtherProceedingSpecialityID

Code

FurtherProceedingSpecialityID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna IssuedBecauseHCProviderChange tabeli OncologyHospital

Definicja kolumny IssuedBecauseHCProviderChange tabeli OncologyHospital

Name

IssuedBecauseHCProviderChange

Code

IssuedBecauseHCProviderChange

Data Type

NUMBER(3)

Mandatory

No

Comment

Czy karta zostala wydana z powodu zmiany swiadczeniodawcy


Kolumna FurtherProceedingSpecialityDT tabeli OncologyHospital

Definicja kolumny FurtherProceedingSpecialityDT tabeli OncologyHospital

Name

FurtherProceedingSpecialityDT

Code

FurtherProceedingSpecialityDT

Data Type

DATE

Mandatory

No

Comment

Data skierowania na dalsze postepowanie w podanej specjalizacji.


Lista kluczy tabeli OncologyHospital

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli OncologyHospital

Definicja klucza Identifier_1 tabeli OncologyHospital

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment